November 29, 2018
slides > slide.backdrop { background: white; }
Analysis Plan
Analysis Outline
Which roadtype are accidents most prone to occur?
Which time of day, and day of week are accidents most frequent?
Factors causing traffic accidents
Weather, road, light conditions
Number of vehicles
Government spending on Transportation infrastructure
Oil price
Comparisons across major districts
Data Introduction - Primary
- Name: Road Safety data, 2011-2017
- Source: Department for Transport
- Dimension: ~990,000 observations with 32 variables
Key Components:
- Accident Location: Longitude, Latitude
- Accident Description: Accident_Severity, Number_of_Vehicles, Number_of_Casualties, Day_of_Week
- Circumstance: Road_Type, Speed_limit, Light_Conditions, Weather_Conditions, Road_Surface_Conditions
Data Introduction - Secondary
- Name: Government spending over £25,000 on transportation
- Source: Office of Rail and road
- Dimension: ~26,000 observations with 18 variables
Key Components:
-Expense.type, Expense.area, Description, Allocation.Date
Exploration and Result
Geographic Distribution
Major districts:
-Glasgow
-Manchester
-London
-Bristol
These areas will serve as the unit for all our analysis
Road Type
Majority of accidents happen on
-Single carriageway
The central reservation to separate opposing flows of traffic is essential to safety.
Accidents by Months
-Least frequent: February and August
-Gradual decrease in accidents numbers from 2011 to 2017
Time of Accidents
Most accidents occur:
-During weekdays: 8:00-10:00; 16:00-18:00
-During weekends: 12:00-16:00
Time of Accidents
Day of Week of Accidents
Most accidents occur:
Tuesday to Friday
Gradual increase through the week
Day of Week of Accidents
Weather Condition
Light Condition
Road Condition
Vehicles vs Casualties
-Mostly 1-2 vehicles
-Pile-up is less likely, but more fatal
Government Spending
-The amount of government spending on transportation across districts
Government spending
-Sum the government spending for major districts
-Juxtapose with the number of traffic accidents
Oil Price
-The oil close price from 2012 to 2017
-Positive correlation with daily accidents
Killer Plot
Conclusion
Analysis Synthesis
-Most fatal accidents occur on Single carriageway
-Accidents are least frequent during the holiday season
-Accidents are more likely to happen on weekdays, and during rush hours
-Oil price has a slight positive correlation with daily accidents
-Traffic factors have a strongest impact on accident numbers in London